how to configure SQL server in google cloud?

Question

Nishi Tiwari · Answer

Configure the SQL Server 
and In SQL Server 2014 Management Studio, click the Security folder for the library SQL Server instance.
Right-click Logins and select New login. and For Login name, enter “dotnetapp”. and For the Authentication method, click SQL Server Authentication. and For Password, enter a password of your choice. Don't enable the Enforce password policy option.
and Change the Default Database to be the “bookshelf” database you previously created.
and In the left side of the New login dialog, click User Mapping and complete the following steps:and 
a. For the bookshelf database, click the Map checkbox. 
b. Under Database role membership for: bookshelf, click all of the roles except for the following:
• db_denydatareader 
• db_denydatawriter 
and To create the new database login account, click OK. and The user you created is set to use SQL Server authentication so SQL Server needs to be configured to allow this authentication method. In SQL Server 2014 Management Studio right-click the Library SQL Server instance you created and select Properties.
and In the left-side menu of the Server Properties dialog, click Security. and For the Server Authentication setting, select SQL Server and Windows Authentication mode, and then click OK.
To restart the SQL Server service, right-click the Library SQL Server instance and select Restart.

forum

how to configure SQL server in google cloud?

Nishi Tiwari

Can you answer this question?

1 Answers

Liked By